UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q8pdatlxNqoCN4OZK+2Hpa9a3SHkcdYkLoE3Hv2Mh58='
WHERE
key_id = '83f6ea4524b8c7a834bcc7b933a4a11d47e5549b2bd08e516125f4db9e6056de'
AND (
token = 'Q8pdatlxNqoCN4OZK+2Hpa9a3SHkcdYkLoE3Hv2Mh58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)