UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4SZcVMRiUY0WYmBNl9tvvI8lzEFBYzYmHgxaRDIZAUw='
WHERE
key_id = '6404caf51cbea881f7f7da58ccb7f9ea8ad07056d61717cee411d3179ee637a6'
AND (
token = '4SZcVMRiUY0WYmBNl9tvvI8lzEFBYzYmHgxaRDIZAUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)