UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6gIlSz3wSmBRKmpCLFFGfJwjQaonboBMyZG06UYbGs='
WHERE
key_id = '10165cc27e0f1cc3f663e480f9acba07ff1ca453e063e3e0fb336bb825ca6494'
AND (
token = 'o6gIlSz3wSmBRKmpCLFFGfJwjQaonboBMyZG06UYbGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)