UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LQqiOLUuDOXy1Gpj3BPgdaDqS6bB3T9D95UXx6efns='
WHERE
key_id = 'cc31c073e4b12add75fb95c808619bb2dfede6ee17204c33b4407f6d9f0e1182'
AND (
token = '9LQqiOLUuDOXy1Gpj3BPgdaDqS6bB3T9D95UXx6efns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)