MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.36

CREATE TABLE events (
    meta JSON
);

INSERT INTO events (meta) VALUES 
    ('{"tags": ["Key1:value1", "Key2:value2"]}');
SELECT cast(meta as char)
FROM events 
WHERE LOWER('Key1:VaLuE1') MEMBER OF(LOWER(JSON_UNQUOTE(JSON_EXTRACT(meta, '$.tags'))));

cast(meta as char)

{"tags": ["Key1:value1", "Key2:value2"]}