UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzYzzR52PWJURh2WsvF6kgAr2784ESJvi4JbcMgbr7U='
WHERE
key_id = 'c491737bbd720aa441437a01c827e6df0ffabdbbe4308290e0b9f4479e0437ce'
AND (
token = 'VzYzzR52PWJURh2WsvF6kgAr2784ESJvi4JbcMgbr7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)