update ACCESS_IPS
  set lat = (select latitude from maxmind.geolitecity_location as a
                where  a.locid = ACCESS_IPS.locid limit 1),

      lon = (select longitude from maxmind.geolitecity_location as b
                where  b.locid = ACCESS_IPS.locid limit 1)
      ;