update users a
    set a.location =
     (select b.location 
      from classes b
      where b.class = a.class)