SELECT 
  1 
FROM 
  tmall_lock_keys 
WHERE 
  key_id = 'c02851104ffbc0cf2bc6bd7294139f5b406809997df8ca91883ab00c83991e93' 
  AND token = '2iNaCMDpnPp90EkJefB/8BL+KBO1ZgNWxJGXrCWw+xQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00882

JSON explain

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