UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cQQ5sT/MXjEWJGVYMwAJBrmLsN645tSe8dEv7RVoWMA='
WHERE
key_id = '6bc8bf765ea8f27dcd6e4e06f5bfefed1ad7c965a0f76e4fc396ee82b5e8a3d2'
AND (
token = 'cQQ5sT/MXjEWJGVYMwAJBrmLsN645tSe8dEv7RVoWMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)