I know it is still early in the day, but given the logic of the select and update, would this not work?

UPDATE AGS_Hands_InProcess SET

Win= 5, -- the value from the matching Adjustement

ts= getdate() -- the timestamp of last action on this hand

WHERE WIn is NULL -- unfinished games

and ts_started < dateadd(hh,-1,getdate()) -- older than 1 hour

--note: sort doesn't matter here