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