UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJKc0drYu8Og+UOnCBqrco0YqLjqiClU5QuMv3acmnw='
WHERE
key_id = 'b176f14a8bf7a9d58da7cbd522a45cefa17e184f163980fcae65a9ee94c39ac8'
AND (
token = 'zJKc0drYu8Og+UOnCBqrco0YqLjqiClU5QuMv3acmnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)