UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'biJDkIpzZLDFlb0oWjFk2EmJWIG4A5ThHTSEVXziQOU='
WHERE
key_id = '7a196468088042ac5d62625f71c7493f1f964260b6ac956a391f7ac62a1ae370'
AND (
token = 'biJDkIpzZLDFlb0oWjFk2EmJWIG4A5ThHTSEVXziQOU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)