Slow UPDATE FROM Query in Large Table
I would index geoid10 on both tables.  If you can commit partial results, commit every 1000 to 10,000 updates.  You should be able to do the updates in a stored procedure.  This may reduce the overhead for lock contention.