Watch out for @@identity - if there is a trigger which causes rows to be inserted in another table you will get the id of the LAST row inserted, regardless...

My Gosh, TUNE THE SQL!!!! Dont write updates that add to your problems.  It may be a simple as having the proper index that includes the shipping date.