UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oz1JZVY2JIVVw6Y1DLIFopkVy4AcIW5IC0VKG+mHPXs='
WHERE
key_id = 'e24f82b4d898e22c0fcde4e54ec5d83ff9daabcef27b42b2858d32927a65c438'
AND (
token = 'oz1JZVY2JIVVw6Y1DLIFopkVy4AcIW5IC0VKG+mHPXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)