MySQL JSON - How to extract a "value" for a particular "Key" from an array of Named Key/Value Pairs

Question

Given a JSON path that contains an array of Named Key/Value pairs, how to extract the "Value" for the "Name" pair:

# JSON_PRETTY(JSON_EXTRACT(data, '$.Tags'))
[
    {
        "Key" : "Environment",
        "Value" : "Production"
    },
    {
        "Key" : "Description",
        "Value" : "Production Message Broker"
    },
    {
        "Key" : "Version",
        "Value" : "1"
    },
    {
        "Key" : "Application Role",
        "Value" : "Message Broker"
    },
    {
        "Key" : "Reserved Instance",
        "Value" : "Y - 3 year"
    },
    {
        "Key" : "Patch Group",
        "Value" : "Saturday9am"
    },
    {
        "Key" : "Name",
        "Value" : "mb023323"
    }
]

IE, how do I get the "Name" "Value"? "mb023323" in this example?

I've reviewed numerous articles and books, but can find no query that addresses what I need. (Of course, I may just not understand how to specify a JSON path correctly.)