Deadlock Explanation
When running the second statement, each session has already inserted rows in adt.[ClientBusinessUnitBehaviour], and has those new rows exclusively locked.  

The UPDATE statement may need to read the new rows inserted by the other session to discover if they have a NULL RowVersion column.