conditionally update from values in a second file

[dnlwgnd]

I need to update in a yaml file parts of a value from values in a second yaml file. specifically using this representative test case:

test.yaml:

spec:
  template:
    spec:
      containers:
      - name: some-backend
        image: my.registry.com/some/some-backend@sha256:11aa
      - name: some-backend2
        image: my.registry.com/some/some-backend@sha256:11aa
      - name: some-backend3
        image: my.registry.com/some/some-other@sha256:abcd

trigger_payload.yaml:

event_type: pushImage
events:
  - full_name: some/some-backend
    image_id: 22aa
  - full_name: some/some-frontend
    image_id: 56ab

I need to update each image-id in test.yaml from the image_id given in trigger_payload.yaml if their image names match the full_name and leave them unchanged if they do not match.
the expected result would be

spec:
  template:
    spec:
      containers:
      - name: some-backend
        image: my.registry.com/some/some-backend@sha256:22aa
      - name: some-backend2
        image: my.registry.com/some/some-backend@sha256:22aa
      - name: some-backend3
        image: my.registry.com/some/some-other@sha256:abcd

I was hoping to find a single yq expression to do this, but alas I can quite wrap my head aroud it. I do have a solution looping over the events in trigger_payload.yaml in a bash loop which I do not like too much. Any hints greately appreciated. Thanks!