SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '4c0b0df4f78262d889058ab7c3ccd3fc00a42f06b4615436cd94a9772fda2ab7' 
  AND token = 'zBb1cs/us5UT8C3+Cn4c9xExtpPMhaWlPYE/NlpqEu4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

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