We walk in the dark places no others will enter
We stand on the bridge and no one may pass

 UPDATE dbo.TableA
    SET TableAStatusTypeID = 9
  WHERE WaitingRoomCreationTime <= DATEADD(mi,-@wrExpirationMinutes,@curUtcDate)
    AND TableAStatusTypeID IN (1,2,3,4)
;

 DELETE FROM dbo.TableA
  WHERE TableAStatusTypeID IN (11,12)
;

 SELECT TOP (@TOP_HANDLED_ROWS) 
        TableAID
   INTO #MyHead
   FROM dbo.TableA 
  WHERE TableAStatusTypeID IN (11,12)
  ORDER BY TableAID
;
 DELETE FROM dbo.TableA
  WHERE TableAID IN (SELECT TableAID FROM #MyHead)
;

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WITH TableA_CTE AS(
SELECT TOP (@TOP_HANDLED_ROWS)
    TableAID,
    TableAStatusTypeID,
    LastUpdateTime
FROM
    dbo.TableA
WHERE
    WaitingRoomCreationTime < dateadd(minute, -@wrExpirationMinutes, @curUtcDate)
    AND TableAStatusTypeID IN (1,2,3,4) -- CreatePending/Creating/Created/CreatedReportFailed
ORDER BY
    WaitingRoomCreationTime asc
)
UPDATE TableA_CTE SET
    TableAStatusTypeID	= 9, 
    LastUpdateTime	 = @curUtcDate;
go