UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NANQ0AC1S5IbBgBmPJsaTf/qosqLxwEUALekc9T5eEA='
WHERE
key_id = 'ca4146895b5317f192b4b59553f8d0039b26ef7f15eec36356e98c5ecbe5e11e'
AND (
token = 'NANQ0AC1S5IbBgBmPJsaTf/qosqLxwEUALekc9T5eEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)