UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kNZCib5NzwlCCau3lKpgEK5i4vO4QygeJyqVVlPtsc0='
WHERE
key_id = '6993a9b038258aaa8d8d6bf5d51e40b411925cbd5d3b00840a369e83b9e3cd4e'
AND (
token = 'kNZCib5NzwlCCau3lKpgEK5i4vO4QygeJyqVVlPtsc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)