use tempdb;
go

create table dbo.t(id int primary key, v int);
insert into dbo.t values (1, 1);
go

begin tran;
update dbo.t set v = 2 where id = 1;
exec sp_lock @@spid;
select * from dbo.t with (paglock, repeatableread) where id = 1;
exec sp_lock @@spid;
commit;
go

drop table dbo.t;
go

            SELECT
             ...
            FROM
             (
              select top (cast(0x7fffffff as int))
               ...
              from
               n_OrderDetail od
               JOIN OrdersToExport ote ON ote.order_num = od.order_num
              WHERE
               ote.order_num = @P1
              order by
               od.serv_id
             ) ttt
             LEFT loop JOIN n_order_marketing_complex_service omcs ON omcs.order_num = ttt.order_num AND omcs.complex_id = ttt.serv_id

CREATE NONCLUSTERED INDEX [in_n_order_marketing_complex_service$complex_id$order_num$service_id$price$total] ON [dbo].[n_order_marketing_complex_service]
 ([complex_id], [order_num], [service_id])
INCLUDE
 ([price], [total])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, drop_existing = on) ON [PRIMARY]

with t as
(
 select top (cast(0x7fffffff as int))
 from
  [dbo].[n_order_marketing_complex_service]
 where
  aid in (3028507, 3028504, ..., 3028506)
 order by
  complex_id, order_num, aid
)
update t
 set
  [total] = :yp0, [bonuses] = :yp1;