UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RORopIwCz5MVGzhVAU2TjD6pimJL10FiEasmYJgA9xQ='
WHERE
key_id = 'a1264746b64471a0671d8acd4aee887c0bcc5051e1c0864154f4c9e64a0a84be'
AND (
token = 'RORopIwCz5MVGzhVAU2TjD6pimJL10FiEasmYJgA9xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)