MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE ssp_models( json_data JSON );
INSERT INTO ssp_models VALUES
(
'{
  "system-security-plan": {
    "uuid": "66c2a1c8-5830-48bd-8fdd-55a1c3a52888",
    "metadata": {
      "title": "Enterprise Logging and Auditing System Security Plan",
      "last-modified": "2019-09-23T18:14:50.591Z",
      "version": "1.0",
      "oscal-version": "1.0.0-rc1",
      "roles": [
        {
          "id": "legal-officer",
          "title": "Legal Officer"
        }
      ],
      "parties": [
        {
          "uuid": "3b2a5599-cc37-403f-ae36-5708fa804b27",
          "type": "organization",
          "name": "Enterprise Asset Owners"
        },
        {
          "uuid": "833ac398-5c9a-4e6b-acba-2a9c11399da0",
          "type": "organization",
          "name": "Enterprise Asset Administrators"
        },
        {
          "uuid": "ec485dcf-2519-43f5-8e7d-014cc315332d",
          "type": "organization",
          "name": "Legal Department"
        },
        {
          "uuid": "0f0c15ed-565e-4ce9-8670-b54853d0bf03",
          "type": "organization",
          "name": "IT Department"
        },
        {
          "uuid": "96c362ee-a012-4e07-92f3-486ab303b0e7",
          "type": "organization",
          "name": "Acme Corp"
        }
      ]
    }
    }
 }'
)
SELECT JSON_PRETTY(json_data) FROM ssp_models


JSON_PRETTY(json_data)


{
  "system-security-plan": {
    "uuid": "66c2a1c8-5830-48bd-8fdd-55a1c3a52888",
    "metadata": {
      "roles": [
        {
          "id": "legal-officer",
          "title": "Legal Officer"
        }
      ],
      "title": "Enterprise Logging and Auditing System Security Plan",
      "parties": [
        {
          "name": "Enterprise Asset Owners",
          "type": "organization",
          "uuid": "3b2a5599-cc37-403f-ae36-5708fa804b27"
        },
        {
          "name": "Enterprise Asset Administrators",
          "type": "organization",
          "uuid": "833ac398-5c9a-4e6b-acba-2a9c11399da0"
        },
        {
          "name": "Legal Department",
          "type": "organization",
          "uuid": "ec485dcf-2519-43f5-8e7d-014cc315332d"
        },
        {
          "name": "IT Department",
          "type": "organization",
          "uuid": "0f0c15ed-565e-4ce9-8670-b54853d0bf03"
        },
        {
          "name": "Acme Corp",
          "type": "organization",
          "uuid": "96c362ee-a012-4e07-92f3-486ab303b0e7"
        }
      ],
      "version": "1.0",
      "last-modified": "2019-09-23T18:14:50.591Z",
      "oscal-version": "1.0.0-rc1"
    }
  }
}


UPDATE ssp_models 
   SET json_data = JSON_REMOVE(json_data, 
                       REPLACE(
                        JSON_UNQUOTE(
                            JSON_SEARCH(json_data, 'one', '3b2a5599-cc37-403f-ae36-5708fa804b27')
                            ),'.uuid',
                       ''))
SELECT JSON_PRETTY(json_data) FROM ssp_models


JSON_PRETTY(json_data)


{
  "system-security-plan": {
    "uuid": "66c2a1c8-5830-48bd-8fdd-55a1c3a52888",
    "metadata": {
      "roles": [
        {
          "id": "legal-officer",
          "title": "Legal Officer"
        }
      ],
      "title": "Enterprise Logging and Auditing System Security Plan",
      "parties": [
        {
          "name": "Enterprise Asset Administrators",
          "type": "organization",
          "uuid": "833ac398-5c9a-4e6b-acba-2a9c11399da0"
        },
        {
          "name": "Legal Department",
          "type": "organization",
          "uuid": "ec485dcf-2519-43f5-8e7d-014cc315332d"
        },
        {
          "name": "IT Department",
          "type": "organization",
          "uuid": "0f0c15ed-565e-4ce9-8670-b54853d0bf03"
        },
        {
          "name": "Acme Corp",
          "type": "organization",
          "uuid": "96c362ee-a012-4e07-92f3-486ab303b0e7"
        }
      ],
      "version": "1.0",
      "last-modified": "2019-09-23T18:14:50.591Z",
      "oscal-version": "1.0.0-rc1"
    }
  }
}