UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3GWRl3/0399gOwEuRk0KSsgk/seXeLh1Z3kFc0AzpyY='
WHERE
key_id = 'def540dcf32fcc845512017c95f0d398e12f33674fb429a902e8f9fc22ae62f1'
AND (
token = '3GWRl3/0399gOwEuRk0KSsgk/seXeLh1Z3kFc0AzpyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)