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