SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '858508e60b82c69f4d63816f14e77ff1100092fdb8b4e29aa5a69c6d6e2600d8' 
  AND token = '45zNIgjDsb4B1/cCLpw1fAAKyWk6OIc5uELtRJ0F6kU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00057

JSON explain

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