UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '16jAsx7he70yla9BKZdwkyIg91DDncn5KFRTUsVhaC0=' 
WHERE 
  key_id = '75dd43b59d356b0bd9fda9d30d8d0f9df15cbca65cacff35bea77ca212ecf909' 
  AND (
    token = '16jAsx7he70yla9BKZdwkyIg91DDncn5KFRTUsVhaC0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037