UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpEq66j9arIRG31wU5LBEyXmovwSGrNvorAU9x9UmvI='
WHERE
key_id = '2665149eb0728490443d805f6996e1dd29c67526a74e916af97a7e5a130fa707'
AND (
token = 'zpEq66j9arIRG31wU5LBEyXmovwSGrNvorAU9x9UmvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)