wpdb – How to query more than one meta key and value with SQL

I am trying to add a second condition to my SQL where I select from a specific role and another meta key. It works fine with just the role condition but when I try to add the second one it doesn’t work.

SELECT xxxx FROM wp_users 
JOIN wp_usermeta
ON wp_usermeta.user_id = wp_users.id
WHERE wp_usermeta.meta_key = 'wp_capabilities'
AND wp_usermeta.meta_value LIKE '%custom_role%'

// works up until here
AND wp_usermeta.meta_key = 'another_meta_key'
AND wp_usermeta.meta_value LIKE '%another_meta_value%'