No need for `JOIN LATERAL` (or do you *really* just want to use it?); an `UPDATE` will pass each rows `SET` value to the following query, which is the same concept as using a `JOIN LATERAL`.<br><br>Try

    UPDATE gps
    SET stop_id = (
      SELECT stop_id
      FROM stops
      ORDER BY gps.geom <-> stops.geom
      LIMIT 1
    );

<br>
*You are a very experienced PostGIS user; still, let me add some notes on distances and the KNN operator ,)*<br><br>
In my experience, for points the `<->` operator tends to perform even slightly slower than with plain old `ST_Distance` (check if the index scan actually kicks in with `<->`). For better precision, consider casting to geography; the `<->` operator then measures on a sphere, while `ST_Distance` uses the actual spheroid.<br><br>
If the tables are massive, you can add a `WHERE ST_DWithin(gps.geom, stops.geom, <apt_distance>)` to only compare those `stops` in each `gps` points' vicinity (note that the distance given uses the CRS units (i.e. degrees for *EPSG:4326*) for *geometry*, but meter for *geography*).