@Teff, Simon I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.
Issue: Unable to unlock a tfstate file in Terraform blob storage
Error: Error acquiring the state lock: state blob is already locked
Solution: To release a lock on a Terraform state file stored in Azure Blob Storage, perform the following actions:
- Navigate to the Azure Portal and locate the storage account containing your state file.
- Within the relevant container, locate the lock file that corresponds to your Terraform state. Typically, this file has a .tflock extension and is named after your state file.
- Delete this lock file to release the state lock, enabling other users to make changes to the infrastructure defined in the state file.
Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.