SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8784aaa3620558172f78c2a7090f074af6c1a238cd2a12565433c1f7c593828c' 
  AND token = 'TKTm3G+RwiupkQjM2Omgbq326om7wV3IHIbKQz94Yb4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}