UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfE6Q+fMytq0ssckrRS1LKDGn3L5Gnex9KCam1MFixw='
WHERE
key_id = 'a1dba45c89f3971ae5638025042b5e44a05842bab2fb47f29e1bb29612a54577'
AND (
token = 'xfE6Q+fMytq0ssckrRS1LKDGn3L5Gnex9KCam1MFixw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)