UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dY8S2hHPzN9vtXGMvW6JuxUhOtOgzcHVuSL36Z//XEg='
WHERE
key_id = 'c59f583cb1b5c027b19bf6685bfd436de3f3fb5dc85c2914fcbba2630a93ee88'
AND (
token = 'dY8S2hHPzN9vtXGMvW6JuxUhOtOgzcHVuSL36Z//XEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)