Can we use LOCK IN SHARE MODE instead of FOR UPDATE for Series Table

Getting deadlock while doing more concurrent transaction.

You can’t use share mode on tabSeries, because semantics require an exclusive lock on the counter.

Deadlock is most likely not from this query but a combination of other queries. Check show engine innodb status right after a deadlock occurs.