Update product price if specific meta_key contains a specific meta_value

In Wordpress / Woocommerce database there is a wp_postmeta table.

I am try to update the meta_value = '0' where meta_key = '_price' only if another meta_key = 'group' and meta_value = 'glass' exist for the same post_id.

This is what I have tried:

UPDATE wp_postmeta SET meta_value = '0'
WHERE meta_key = '_price' AND meta_key = 'group' AND meta_value = 'glass';

And This one too:

  UPDATE 
        `wp_postmeta` 
    SET 
        `meta_value` = '0' 
    WHERE 
        meta_key = '_price' 
        AND `meta_key` IN (
            SELECT 
                `meta_value` = 'glass' 
            FROM 
                `wp_postmeta`
        );

Those attempts doesn't work.

How can I update the meta_value = '0' (for meta_key = '_price') only if the meta_key = 'group' and meta_value = 'glass' exist for the same post_id?

Any help is appreciated.