How to order posts by one custom field and filter them by another one?

This is not going to work, because you are setting same meta_key parameter twice with different values and only one will be effective.

Rather than building raw queries it is better to use filters to modify WP query. Query Overview documentation has list of hooks where you can insert your mods (as the end under What Plugins can Modify).