SELECT 
  1 
FROM 
  tmall_lock_keys 
WHERE 
  key_id = '2075895524764be029137ecbebe4e5b59cefd17057a27439edd6ca603c794c7a' 
  AND token = 'FzG8VxSVxjjR7YJVrA/m18/t3pGwKkzuXY8DIfB5ojA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00944

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}