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