UPDATE mytable SET
   door_open = door_open + 1,
   door_close = door_close + 1,
   car_open = car_open + 1,
   car_close = car_close +1,
   ... blah blah ...
  WHERE
   ...