one case could be multiple upgrade scripts in the patch are there, and ad workers are running them parally , so when the first worker was upading the table and second one also gone for the update at the same time, in this case locking error will come.

To resolve this kind of issues patch should not contain different upgrade scripts for a single table ,all the upgrades should happen in the same file.