Reducing deadlocks with update query hint or other method
I resolved the deadlocks by using a NOLOCK hint in the first select statement.
No dirty reads as this is the only process that manipulates the rows and only does so once.