UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YocbHpjdHUToh0ehlxCVR13KAhz0S6tbroc6+3GdtyQ='
WHERE
key_id = 'ecc616c35fe872f85bb2dceb66e4bc57b371e8c4db0d2b55c0efc2b7b1127062'
AND (
token = 'YocbHpjdHUToh0ehlxCVR13KAhz0S6tbroc6+3GdtyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)