We should be able to obtain and update the value of a sequence locking the node using the trick of deleting a non existing property.

This has the benefit to obtain the value running only one query (instead of looking for the node and than update it) and the dialect does not need to access the transaction to lock the node.