### Is there an existing issue for this?

- [X] I have searched the existing issues

### Current Behavior

with python boto3 client

- send a message to fifo queue with MessageGroupId='1'
- receive the message
- delete the message
- send another message to the queue with MessageGroupId='1'
- try to receive the message, get none
- check message availability with get_queue_attributes, get `{'ApproximateNumberOfMessages': '1', 'ApproximateNumberOfMessagesNotVisible': '0', 'ApproximateNumberOfMessagesDelayed': '0', ...`

### Expected Behavior

expecting to receive message from the queue

### How are you starting LocalStack?

With a docker-compose file

### Steps To Reproduce

docker-compose up


### Environment

```markdown
- OS:MacOS Sonoma 14.2.1
- LocalStack: latest
```


### Anything else?

I tried to run with Rosetta, no result
queue_url = sqs_create_queue(
            Name=f"queue-{short_uid()}.fifo",
            Attributes={
                "Fifo": "true",
                "ContentBasedDeduplication": "true",
            },
        )
        assert get_qsize(aws_sqs_client, queue_url) == 0
        aws_sqs_client.send_message(Url=queue_url, MessageBody="g1-m1", MessageGroupId="1")
        aws_sqs_client.send_message(Url=queue_url, MessageBody="g1-m2", MessageGroupId="1")
        aws_sqs_client.send_message(Url=queue_url, MessageBody="g1-m3", MessageGroupId="1")
        aws_sqs_client.send_message(Url=queue_url, MessageBody="g2-m1", MessageGroupId="2")
        aws_sqs_client.send_message(Url=queue_url, MessageBody="g3-m1", MessageGroupId="3")
        assert get_qsize(aws_sqs_client, queue_url) == 5
        response = aws_sqs_client.receive_message(
            Url=queue_url, MaxNumberOfMessages=4, WaitTimeSeconds=1
        )
        if os.environ.get("TEST_TARGET") == "AWS_CLOUD":
            time.sleep(5)
        assert get_qsize(aws_sqs_client, queue_url) == 1
        for message in response["Messages"]:
            aws_sqs_client.delete_message(
                Url=queue_url, ReceiptHandle=message["ReceiptHandle"]
            )
        if os.environ.get("TEST_TARGET") == "AWS_CLOUD":
            time.sleep(5)
        assert get_qsize(aws_sqs_client, queue_url) == 1
    @markers.aws.validated
    @pytest.mark.xfail(reason="not implemented in localstack at the moment")
    def test_fifo_delete_message_with_expired_receipt_handle(