Solved.

For anyone having similar issues it needs to read like the below.

UPDATE 
    users_profiles
INNER JOIN 
    users
ON
    users.user_uid = users_profiles.user_uid
SET 
    users_profiles.user_fname = 'John', 
    users_profiles.user_lname = 'Doe', 
    users_profiles.user_gender = 'male'
WHERE
    users.user_login = 'johndoe'
AND
    users.user_uid = '11'

Cheers.