UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkbnKea8g0Tkt9sJNZXgqpd/9QD/7Fk/wPU8wAApzrk='
WHERE
key_id = 'a9c02336808da062271898a301e18b1ae5123e714222d8d6feea546af7512e3c'
AND (
token = 'zkbnKea8g0Tkt9sJNZXgqpd/9QD/7Fk/wPU8wAApzrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)