UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWZz+LOCU9ksb2p0ccd6Rhc8AHyZuGls+DdzmLdsMXw='
WHERE
key_id = '5fb691b5012c2ccfde09bfff47974aecc3df0e23b4fb689766de58ff5f6df558'
AND (
token = 'XWZz+LOCU9ksb2p0ccd6Rhc8AHyZuGls+DdzmLdsMXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)