SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6a02f7db21ed1ab8c2eb08ed20cb5762ea5760ad78b95b6dfa0c99678b25630d' 
  AND token = 'wFgfkSXRDA65b5HBQs+StGBIlKTBfJu1kRriqvg+vHM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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