UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IL7lJiqf0hcM75rzZsd/4fQecAWDcju6wyundFegmPg='
WHERE
key_id = 'b424e04dbab81e2e8dd4298c45020e9609edf6171b595b4d31f5d9ecaa8417f6'
AND (
token = 'IL7lJiqf0hcM75rzZsd/4fQecAWDcju6wyundFegmPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)