UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BTDYmsaAK8ZKTX3gtudgDavmAX/iHg7GBfirKFvUf4c='
WHERE
key_id = 'dfa47f16b0d0a6b61db193e88e89adae5c9598abc31eeb7dfbff1c23f03c142f'
AND (
token = 'BTDYmsaAK8ZKTX3gtudgDavmAX/iHg7GBfirKFvUf4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)