UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EyTI0OckDDUoEjLJVdZG1TiKWHqqW0TwEA3LC6N1C7g='
WHERE
key_id = '1e737180fbc14bc5bbe49154c52dbf77f7f9369457eef6953416d3e14a684b3a'
AND (
token = 'EyTI0OckDDUoEjLJVdZG1TiKWHqqW0TwEA3LC6N1C7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)