### Is there an existing issue for this?

- [X] I have searched the existing issues

### Current Behavior

When re-subscribing an SQS queue to an SNS topic with the attribute "RawMessageDelivery=true", localstack throws an error.
It's occuring both on my AWS Java Client and with CLI awslocal
it's working well without this attribute


### Expected Behavior

Since the queue is subscribed with the attribute "RawMessageDelivery=true" to the topic already, it should be a no-op and simply return the same subscription arn.



### How are you starting LocalStack?

With a docker-compose file

### Steps To Reproduce

#### How are you starting localstack (e.g., `bin/localstack` command, arguments, or `docker-compose.yml`)

    docker run localstack/localstack

#### Client commands (e.g., AWS SDK code snippet, or sequence of "awslocal" commands)

```
awslocal sns create-topic --name localstack-topic
awslocal sqs create-queue --queue-name localstack-queue

awslocal sns subscribe   --topic-arn arn:aws:sns:eu-central-1:000000000000:localstack-topic    --protocol sqs    --notification-endpoint arn:aws:sqs:eu-central-1:000000000000:localstack-queue    --return-subscription-arn  --attributes RawMessageDelivery=True

awslocal sns subscribe   --topic-arn arn:aws:sns:eu-central-1:000000000000:localstack-topic    --protocol sqs    --notification-endpoint arn:aws:sqs:eu-central-1:000000000000:localstack-queue    --return-subscription-arn  --attributes RawMessageDelivery=True
```

### Environment

```markdown
aws-cli/1.22.34 Python/3.10.12 Linux/6.2.0-32-generic botocore/1.31.47
```


### Anything else?

subscription created with "RawMessageDelivery=true"

![image](https://github.com/localstack/localstack/assets/98832464/faac719d-b5fe-4920-a756-28abc17fd0e7)


but if the subscription is created without attributes it's working well 

![image](https://github.com/localstack/localstack/assets/98832464/44ed7afd-a3b2-4a19-aff4-cba7b75ad52c)


maybe it's related to https://github.com/localstack/localstack/issues/9058
), f"invalid number of messages in DLQ response {response}"
        if raw_message_delivery:
            assert response["Messages"][0]["Body"] == message
        else:
            received_message = json.loads(response["Messages"][0]["Body"])
            assert received_message["Type"] == "Notification"
            assert received_message["Message"] == message
        receipt_handle = response["Messages"][0]["ReceiptHandle"]
        aws_client.sqs.delete_message(QueueUrl=dlq_url, ReceiptHandle=receipt_handle)
        expected_unsubscribe_url = (
            f"{service_url}/?Action=Unsubscribe&SubscriptionArn={http_subscription_arn}"
        )
        unsub_request = requests.get(expected_unsubscribe_url)
        unsubscribe_confirmation = xmltodict.parse(unsub_request.content)
        assert "UnsubscribeResponse" in unsubscribe_confirmation
        response = aws_client.sqs.receive_message(QueueUrl=dlq_url, WaitTimeSeconds=2)
        # A
        assert "Messages" not in response
class TestSNSSubscriptionFirehose:
    @markers.aws.validated
    def test_publish_to_firehose_with_s3(
        self,
        create_role,
        s3_create_bucket,
        firehose_create_delivery_stream,
        sns_create_topic,
        sns_subscription,
        aws_client,
    ):
        role_name = f"test-role-{short_uid()}"