UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yS8qo6TB0InbEqPF9LzTFZrPDhtA7EFn0RNa9rh83aM='
WHERE
key_id = '11e4065dd584cdf67c8ccd56512dd5d17f0a32ff18fe03daac433a657485bf14'
AND (
token = 'yS8qo6TB0InbEqPF9LzTFZrPDhtA7EFn0RNa9rh83aM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)