UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHSpE9iF+zyU/HY7sRnGpkfooyjZ7bdYrfH+208Zj/w='
WHERE
key_id = '1005c4e6d586e8d925640792148cc56c0408b64e7450d63ed956e8c3f026c6b0'
AND (
token = 'HHSpE9iF+zyU/HY7sRnGpkfooyjZ7bdYrfH+208Zj/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)