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