I had an engine that I had rebuilt, and after it was not used for a long time, it was near impossible to turn over with a long extension lead on a socket on the crank pulley bolt (5/8" I think).
I used a mixture of WD40 and engine oil, left it for 2 days, and gradually it freed up by turning the nut on the crank pulley.
I bought a new high torque starter motor, and eventually the pistons were free enough to turn over with the starter motor.
But, this was a rebuilt engine so I knew there was no blown head gasket/water leak problem, it was just condensation of air in the bores which caused it to partially seize.
It did start, smoked a bit as it burned off all the oil in the bores, but now starts and runs with no apparent problem.