UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'OVO49dup5Rca5RyyLDs7f6KP/oTf3koxhWQujY2xHn8=' 
WHERE 
  key_id = '1ce53e1b0935c61993bf880ac85956b37bc3704be44ef7d4866099f5056510d4' 
  AND (
    token = 'OVO49dup5Rca5RyyLDs7f6KP/oTf3koxhWQujY2xHn8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041