UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9OauXHs9/YXUGKPwwaujuDF+oc2LXCTg6v90U/CDc78='
WHERE
key_id = 'f05814965244e60ecbe8d48c90a4b911df4ffba0b2258e37654d575728bd3abc'
AND (
token = '9OauXHs9/YXUGKPwwaujuDF+oc2LXCTg6v90U/CDc78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)