Trying the test again, but with 2 windows both running your original script concurrently, then both updated 255 rows every time.

I can't explain this, but it must be something to do with the locking (??!)