UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Lfvd27buFTC0Qs4W0T2j0VJr/fedIRBA+6O2vUDKCU='
WHERE
key_id = '77ebe9038c2fab577f2a79d238945d40fca9326aa5ce93dc97f22f1afa8f01ee'
AND (
token = '8Lfvd27buFTC0Qs4W0T2j0VJr/fedIRBA+6O2vUDKCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)